| E-mail |
|
CLICK HERE TO SEE THE COMPUTER SCIENCE ENGINEERING DEPARTMENT OF REC ROURKELA IS ISO-9002 CERTIFIED CLICK HERE TO SEE RECR LISTED IN ERNET On this home page, I'll introduce myself .
My Picture-> click on it to go to my main website
PROJECTS BY CSE DEPTT. REC ROURKELA WANNA HOROSCOPES CLICK HERE........
Sunil Kumar Mahato
Sunil Kumar
Mahato
Experience
Summary :
Extensive experience of about eight
years in software design, development, testing and implementation in Client-Server
large mission critical on-line environment. Proficiency in:
Yapplication
software development
Ycoding
Ytesting
Yperformance
monitoring and tuning
Ytrouble
shooting
Ycustomer
interaction
Also
having experience of about three and half years in Data Warehousing.
Working exposure in HP-UNIX 10.x, Solaris and PC environment using
Oracle 7.1, Oracle WebForms, Visual Basic 4.x, SYBASE SQLserver 10.0.1,
SYBASE APT Workbench 5.2.2, SYBASE Report Workbench 5.2.2 and Gupta SQLWindows
5.0.1. Also exposure in technical evaluation of software and hardware,
preparation of proposals and system study. UNDERGRADUATE IN COMPUTER SCIENCE
ENGG. FROM REC ROURKELA
| Hardware
Platforms |
HP-9000
(E735, H50, E-25, E45), Sun SPARC workstation, Intel based machines |
| Operating
Systems |
HP-UX
10.x, Solaris 2.4, SCO-UNIX, MS-DOS 6.22, Windows-95 and NT |
| RDBMS |
SYBASE
SQLserver 10.0.1, Ingres 5.x, Oracle 7.3 |
| Languages |
C,
Pascal, Assembly Language (8086) |
| Front
Ends |
GUPTA
SQL Windows 5.0.1, Visual C++, SYBASE APT Workbench 5.2.2 |
| Web
Programming |
CGI,
PERL |
| DataWarehousing
Tools |
Business
Objects 4.x and 4.0x, Brio, Web-Intelligence. |
| Case
Tools |
Turbo
Analyst 2.20 |
| Miscellaneous |
Visual
Basic 4.x, CICS, OOP |
Personnel
Details:
| Date
Of Birth |
6th
February, 1971 |
| Current
Employer |
SUN Microsystems, USA. |
| Professional
Experience |
1990-1994 CSE DEPTT. REC ROURKELA
July 1997 - July 2000 (BRI
Inc., USA -
A subsidiary of CMC
Ltd) |
| Contact
Email-id |
mahato@hotmail.com |
| Contact
Phone #s |
1-978-458-4839,
1-978-828-0669 |
Project
Experience:
ASM-GOALING Project
Since April 1999
SUN Microsystems, Chelmsford (Boston) ,
MA
This project is currently under development using lot
of Unix shell scripts, Java programs and stored procedures in Oracle and
Sybase. BRIO software would be used as a reporting tool. When completed,
this would capture and effeciently validate the data coming through new
and existing Contracts throughout the year. At the end of the fiscal year
this data along with the data from other systems would be merged and help
in preparing Goals for the Sales Managers for the next fiscal year. Once
installated, the time taken for the GOALING process would be reduced to
1 month, compared to the 5 months, which is done manually.
| Environment |
Solaris |
| Hardware |
SUN E-450, Ultra-60 |
| Application Software |
CGI, Perl, Oracle, BRIO |
Datawarehousing
Project
Jan
1999
T
Rowe Price, Baltimore, Maryland
Work mainly involved
conversion of reports and universe from Business Objects ver 3.1 to ver
4.11. Also involved in the installation and training also. Provided consultancy
on the security issues involved because of the high volume of users (approx.
300).
| Environment |
Solaris,
NT |
| Application
Software |
Business
Objects 4.x, Sybase 11.x |
Datawarehousing
Project
Dec
1998
3COM,
Santa Clara, California
Work mainly involved
designing of the datawarehouse and preparation of the universes in Business
Objects, to ultimately take over the existing universe, which has gone
outdated with time and requirements. The reports were created using Business
Objects Web-Intelligence and BO 4.x, so that those can be distributed over
the intranet. Also did the system study to identify the drawbacks in the
current system and suggested ways to get rid of those, thereby developing
a datawarehouse that eliminates those drawbacks.
| Environment |
Windows
95, NT |
| Application
Software |
Business
Objects 4.x, BO Web-intelligence, Oracle 7.3 |
Datawarehousing
Project
Nov 1998
Schering Plough, New Jersey.
Actively got involved in this week long assignment to
do a system study on their existing system and network, and suggest proper
tools and ways to go around in re-designing the datawarehouse.
| Environment |
Windows
95, NT |
| Application
Software |
Business
Objects 4.x, BO Web-intelligence, Oracle 7.3 |
Project
on datawarehousing.
May
1998 - September 98
SUN
Microsystems (USA), Milpitas, California.
Work mainly involves
preparation of universe and reports using Business Objects for analysing
the contracts and warranties. It also prepares overview on total sales
and helps in deciding the commissions to be given to the agents. Some of
these reports are also published on the SUN's internal website - every
week-end, month-end and fiscal-month-end.
Responsibility:-
Y
Developing and modifying universes and reports in Business Objects &
queries.
Y
Providing Consultancy to users
YMaintaining
reports on SUN's internal web-site
YWriting
of Unix shell scripts to automate the process of running, generating and
publishing reports.
| Hardware |
Sun
Sparc 5 |
| Environment |
Solaris |
| Application
Software |
Business
Objects, Oracle 7.3 |
Project
on datawarehousing.
Jan
1998 - May 1998
Coherent
Technologies (US), Santa Clara, California.
The work involved
movement of old data from MANMAN system to Oracle. Apart from just movement,
data needed polishing to fit in to the new requirements of the users. Work
also required modification of the existing datawarehouses or designing
of new ones, as well as conversion of old forms into Oracle WebForms so
that users can use through the net. A project involving pulling up of data
from excel sheets and loading on the Oracle Database was also completed
using Visual Basic.
Responsibility:-
YDeveloping
and modifying universes and reports in Business Objects & queries.
Y
Creation of users, and granting of groups and roles.
Y
Installation and setup of the softwares.
Y
Providing Consultancy to users
| Hardware |
Intel
based machines |
| Environment |
Windows
NT and 95 |
| Application
Software |
Business
Objects 4.x and 4.0x, Oracle 7.1, Visual Basic 4.x |
DISTI-
Distribution, Sales and Planning.
August
1997 - Oct 1997
WYSE
Technology (US), San Jose, California.
DISTI Application
has been designed to record, analyze and forecast the revenue and sales
of different WYSE products. Inventory information data is collected from
the distributors (domestic and international) on a monthly basis. This
data is used to compute flow-through i.e. quantity of products sold by
distributors to customers in a given time frame. This requires accurate
and informative reports, to provide the ability to make sound business
decisions such as sales forecasting and planning decision. The reports
generated were not only meant for USA but also for Taiwan.
Responsibility:-
YDeveloping
and modifying reports application in Business Objects thus providing the
user with easy & quick access to database through reports & queries.
Y
Creation of users, groups and roles.
Y
Installation and setup of the software.
Y
Providing Consultancy to users in USA and Taiwan
| Hardware |
Intel
based machines |
| Environment |
Windows
NT and 95 |
| Application
Software |
Business
Objects 4.x and 4.0x, Oracle 7.1 |
INTEGRATED
CARGO MANAGEMENT SYSTEM (ICMS)
Jan 1994 - Jul 1997
Airports Authority
Of India (AAI) IGI Airport, New Delhi
ICMS provides facilities for management of cargo
for Import, Export, Transshipment and Disposal. In addition to cargo operations,
it provides functionality for the associated Accounts & Billing and
Warehouse & Inventory Management. The system incorporates client-server
architecture, distributed relational databases and graphical user interface
capabilities. The entire operation is handled by around 120 transactions
from over 100 on-line terminals located in the cargo complex across a radius
of 2 Km. It has got EDI connectivity with the Customs and remote connectivity
with the Agents and Airlines. The system recently incorporated the facility
of generation, identification and tracking of consignments with the help
of bar-codes.
Responsibilities
YPreparation
of MMI screens for Import, Export and Disposal Modules in SYBASE APT
YPreparation
of SRS of the Project using Case tool (Turbo Analyst 2.20)
YWriting
of Program Specifications and Coding of functions using SYBASE SQLserver,
APT Preparation of Reports using SYBASE Report Workbench and GUPTA Report
Windows
YSystem
Administration activities
YIntegration
and testing
YUnit
testing
YAcceptance
Testing
YTrouble
shooting
YPerformance
monitoring and tuning
YPreparation
of proposals
YCorrespondence
with the customers
| Hardware |
Two
HP H50 in a hot standby mode as servers
Four E45 and PC s
as clients |
| Environment |
HP-UX
10.x, MS-DOS, MS-Windows for WorkGroups, Pathways Access (3.0) |
| Software |
SYBASE
10.0.1, GUPTA SQLwindows 5.0.1 |
Project
: MATERIAL MANAGEMENT SYSTEM (MMS)
May
1995 - Aug 1995
Department
of Posts, India
Material Management
System for the Department of Posts covers all the functions relating to
Procurement, Stock Maintenance, Budgeting, Day to day activities, etc.
Timely generation of invoices, bid evaluation consultancy and prior information
regarding the stock deficits were some of the focus areas. Currently it
caters to around 70 different locations all over India.
Responsibilities:
YInstallation
at new locations
YSystem
software support
YModification,
testing and implementation
YSoftware
maintenance
YCustomer
training
| Hardware |
PC
386 |
| Environment |
SCO-UNIX, |
| Software |
Foxbase
Plus |
Project
: PERSONNEL INFORMATION SYSTEM (PIS)
Oct
1993 -Nov1993
CMC
Limited, Calcutta, India
Personnel Information
System developed for CMC Ltd., Calcutta, involves all the operations dealing
with the day-to-day, monthly and yearly activities of the employees. It
provides vital information like the daily attendance, monitoring of employees
on duty out at customer locations, generation of personnel activities reports
etc.
Responsibilities:
YSystem
Analysis and Design, Preparation of SRS using Case tool (Turbo Analyst
2.20)
YPreparation
of MMI screens in INGRES
YWriting
of Program Specifications
YCoding
of functions using INGRES
YPreparation
of reports using INGRES ReportWorkbench
YIntegration
and testing
YSystem
Administration activities
| Hardware |
PC
386 |
| Software |
INGRES
5.0 |
| Environment |
SCO-UNIX |
Professional
Courses/Trainings Attended:
| TITLE |
SUBJECT |
ORGANISATION |
PERIOD |
| UNDERGRADUATE
GRADUATE COURSE IN COMPUTER SCIENCE ENGG.) |
Computer
Organisation, Data Structures, UNIX, Pascal, C, Assembly, RDBMS-Ingres,
Lotus, OOP and CICS. |
REC
ROURKELA, India |
Mar
93 to Dec 93. |
| GUPTA
SQL Windows 4.0 |
GUPTA
4.0 |
IIS
Infotech, New Delhi, India |
May
1994
(2 weeks) |
| GUPTA
SQL Windows 5.0 |
GUPTA
5.0 |
-do-
|
Mar
1995
(2 weeks) |
| OOP
using Visual C++ |
Visual
C++ 2.0 |
STG,
New Delhi |
May
1996
(1 week) |
| Application
Testing Procedures |
Application
Integration and testing |
CMC
Ltd., New Delhi |
Nov
1996
(1 week) |
| Interweave
Information System, ver-1.0 |
Datawarehouse
concepts, Development of reports and queries. |
Interweave,
San Jose, California, USA |
July
1997
(1 week) |
| BRIO
Basics |
BRIO
designer |
BRIO
Technology, Mtn View, California, USA |
January
1999 (1 day) |
| Advanced course on
BRIO designer |
BRIO Designer and Administrator |
SUN Microsystems, Milpitas, California, USA |
August 1999 (3 days) |
Awards
and Appreciations:
YSpecial
appreciation award for development and implementation of ICMS for AAI.
References
1. Karen
Brandao
3COM, Santa Clara, CA
408-2255991
2. Mukesh
Advani
WYSE Technology, Santa Clara, CA
408-4732025
3. John
Mock
Coherent Technologies, Santa Clara, CA
408-7644316
4. Dr.s.k
Rath
prof. and head CSE DEPTT REC ROURKELA
410-3458637
5. Kathy
Bedell
SUN Microsystems, Boston, USA
781-442-0564
6. Beth
Diggle-Johnson
SUN Microsystems, Palo Alto, CA
CLICK HERE 2 SEE H.O.D CSE DEPTT. OF RECR IS A VISITING PROFESSOR AT GERMAN UNIVERSITY |
